#!/bin/bash
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业,买入价均价'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业 asc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业 desc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 买入价均价'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by asc 买入价均价'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by desc 买入价均价'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 卖出价均价 asc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 卖出价均价 desc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业,卖出价均价 desc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业 desc,卖出价均价'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业 desc,卖出价均价 desc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业 as asc,卖出价均价'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业,卖出价均价 as asc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业 as desc,卖出价均价'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业,卖出价均价 as desc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业 as desc,卖出价均价 as desc'
TNDB_Linux_32bit 拼音排序测试UTF8.TNDB 'select 名字,所属行业,sum(买入价) as 买入价合计,avg(买入价) as 买入价均价,sum(卖出价) as 卖出价合计,avg(卖出价) as 卖出价均价 from Table1 where 名字!="" group by 名字,所属行业 having 名字!="" order by 所属行业 as asc,卖出价均价 as asc'